package com.sy.dynamic.primary;

import com.sy.dynamic.entity.UserPrimary;
import org.apache.ibatis.annotations.*;
public interface UserMapperPrimary {

    @Select("SELECT * FROM USER_0 WHERE USER_NAME = #{name}")
    UserPrimary findByName(@Param("name") String name);

    @Insert("INSERT INTO USER_0 (USER_NAME, AGE) VALUES(#{name}, #{age})")
    int insert(@Param("name") String name, @Param("age") Integer age);

    @Delete("DELETE FROM USER_0")
    int deleteAll();
}
